Create Staging Table in SSMS And Staging Package in SSIS
Download the SQL File attached to the
Run Script that is attached to create your Staging tables in the Staging Database. Once ran, the tables will be made up of these columns.
*Open SSIS and Create a new project and name it - "BuildingPermitsInMiami"
*Open SSIS Toolbox, Create a new package and name it - "BuildingPermits_Staging" Package.
Next , the following components will be dragged in the Control Flow Dashboard;
public void Main()
{
// TODO: Add your code here
string FILEPATH;
string JSONFILENAME;
FILEPATH = Dts.Variables["User::FILEPATH"].Value.ToString();
JSONFILENAME = Path.GetFileName(FILEPATH);
Dts.Variables["User::JSONFILENAME"].Value = JSONFILENAME;
MessageBox.Show(JSONFILENAME);
Dts.TaskResult = (int)ScriptResults.Success;
}
The configuration of the data flow task will be carried on in the next step
The final control flow pane should like this :